Search:

» Home » Business » Applications » Excel VBA and Excel UserForms Training 1

Company:	OzGrid Business Applications
License:	Feature-limited trial
Version:	1
System:	Win 95/98/ME/2000
Size:	11KB
Date Released:	November 11, 2002
Price:	$75.00
Screenshot:	No Screenshot
Downloads:	1873
Homepage:	http://www.ozgrid.com/
Date added:	Sep 19, 2005
Click here to Download

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

BASIC COURSE OUTLINE:
The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.

UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime.

WHY USE US FOR EXCEL TRAINING?
Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

NEWS

So far, nothing for that!

RECOMMENDED DOWNLOADS IN THIS CATEGORY

» Home » Business » Applications (10)

Select page: [1]

» Code 128 Barcode Font Pack 1.0

Our Code 128 Barcode Font Pack lets you create and print high quality Code 128 barcodes (including UCC/EAN-128 - one variant of Code 128) in any program. In addition to the TrueType bar code fonts, our Code 128 font pack also includes Microsoft Office tem ...

32Tech Barcode | 1440KB | Win NT/2000/XP | $135 | Downloads: 1714